UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzlUhbo5jIHF1UXhRQOVZQAzqjUanxC/Ulwr4ITL2rU='
WHERE
key_id = '43e5a21372a58f6b1a77373d55b5cb9a512f6f2f6a92f7e27565f977856c9e8f'
AND (
token = 'VzlUhbo5jIHF1UXhRQOVZQAzqjUanxC/Ulwr4ITL2rU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)