UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qGpJji7jnPtX0//DQ8FtX3UlBvOTlyvVVYmiJUDDoCY='
WHERE
key_id = '9a1b9ebcdb4d23fd53a77dd4acf0d9a6c16cd34a62b8d05bfa31780e2991b9c1'
AND (
token = 'qGpJji7jnPtX0//DQ8FtX3UlBvOTlyvVVYmiJUDDoCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)