UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W3fX9aVHrupUfYPzdwgOpMP9mktfOsQF2F8GUuMGdeM='
WHERE
key_id = '954af4b4c8b815e6567f663e822b3f886e1061bddd4088dd27f9ec8b531b7597'
AND (
token = 'W3fX9aVHrupUfYPzdwgOpMP9mktfOsQF2F8GUuMGdeM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)