UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1S2eSFcvx1+mrH5J50+TJZYKYafoeP5KoLiBvwhfsbM='
WHERE
key_id = 'b947ee9a900f409013aa8098c11663ce356e05fe6322208fbb5959351fda9014'
AND (
token = '1S2eSFcvx1+mrH5J50+TJZYKYafoeP5KoLiBvwhfsbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)