UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xg15dfNtDoAHRAi/Y1E98BerPAkowqj1jpvwPDPjoeQ='
WHERE
key_id = 'd65dc87701221cf165dc2b8d08cc6da94c446ad7dacd9eeb8aef8eeb6ec65bf8'
AND (
token = 'xg15dfNtDoAHRAi/Y1E98BerPAkowqj1jpvwPDPjoeQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)