UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5P23Ov7nj5u5g2H+I3gjBITif0CWNOlgk8lO3JgIaZ8='
WHERE
key_id = '075098a4778f3882b442320713f06dfa80628c070c0e3dc6424f70bb226b7255'
AND (
token = '5P23Ov7nj5u5g2H+I3gjBITif0CWNOlgk8lO3JgIaZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)