UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJNUJRWgRXaSxpuL0GGIHciiovI+LoziB9OnL7nzZog='
WHERE
key_id = '137971cbf600afcfcd1e305b56f545590e4cc2d624c877563c6ea66f6086d26a'
AND (
token = 'BJNUJRWgRXaSxpuL0GGIHciiovI+LoziB9OnL7nzZog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)