UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xN1zkNVlXgIH0Kv0j2WMIJrsBnCvbkVylFdQ+Q8DVFQ='
WHERE
key_id = 'd37660e29268ef96e2e3b10c1efda2abb0e976ae2ac9aee4ac85ae552318eefd'
AND (
token = 'xN1zkNVlXgIH0Kv0j2WMIJrsBnCvbkVylFdQ+Q8DVFQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)