UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UC4q2pIBG8XToUg7v8EvBPMFZKiA1MHyOHsb4aEEpI4='
WHERE
key_id = '480e27067ebf8a003470bd9061252cbfdfe327665cedeaec4816dce03574fffb'
AND (
token = 'UC4q2pIBG8XToUg7v8EvBPMFZKiA1MHyOHsb4aEEpI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)