UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4CRAJVdQC8xVWDk99Ur5eLqgI+VFezgujKf+2/XgXOU='
WHERE
key_id = 'c5b2d111edfad31b0c25f5f73bb75af87072258ae73ac59e45e8c0b7959ce766'
AND (
token = '4CRAJVdQC8xVWDk99Ur5eLqgI+VFezgujKf+2/XgXOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)