UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7u6jG9RHTwOMmY+31hOcBp+R6loiHr6cMNrY10blUCo='
WHERE
key_id = 'eafe255f29a5c74183d4c122df667750b56aadf9f7c0257d93b5dc728be6a15b'
AND (
token = '7u6jG9RHTwOMmY+31hOcBp+R6loiHr6cMNrY10blUCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)