UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i7Va5vLbls10j1XB97ODXmrTJtw5R+EjqG8L+nmJQxU='
WHERE
key_id = 'a212991022118c99e51645e38fc3c8615daaa426435361845d6537d39551b788'
AND (
token = 'i7Va5vLbls10j1XB97ODXmrTJtw5R+EjqG8L+nmJQxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)