UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vjzh0HRJC7vXgXm5q4766t3HeU+h94CYx+kn1zIxPU='
WHERE
key_id = '46bdfd16044e0683d149d9c47264244fb0a996d64b37e010730ad65bf1b3e736'
AND (
token = '6vjzh0HRJC7vXgXm5q4766t3HeU+h94CYx+kn1zIxPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)