UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5iDc3/ynnDbvOKieKUis7XCMJRuxelFHQfkkwsyckso='
WHERE
key_id = 'c0f878341f6c23b052a833dc56888893969b9877a7faba37717e4d1815341fb5'
AND (
token = '5iDc3/ynnDbvOKieKUis7XCMJRuxelFHQfkkwsyckso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)