UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LXBo8mC47jhGOfDayBPhokpKqkmdoY5E7eylmrW6lDs='
WHERE
key_id = '5afcfa98915d0337610d6314cce803375864f590b9174dbd06d44be56897a7e8'
AND (
token = 'LXBo8mC47jhGOfDayBPhokpKqkmdoY5E7eylmrW6lDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)