UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NBBXv4/KMB1MrMFLCNI/7MZWJ8OFMISK2VZzyAIK3+Y='
WHERE
key_id = '4e1807c47114bd0e01dc53c9fdd15a77de1d89cb0e864a39ead1ea838ba4ea7f'
AND (
token = 'NBBXv4/KMB1MrMFLCNI/7MZWJ8OFMISK2VZzyAIK3+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)