UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9kvLzpzO6CmjMT0hHzOUujbNhpDxDO8E+UMBVDdfW70='
WHERE
key_id = '7edf15a0c7bf9ad83cb438ff2ceb365d2ebe273f459df62b810a3830833684ab'
AND (
token = '9kvLzpzO6CmjMT0hHzOUujbNhpDxDO8E+UMBVDdfW70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)