UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XPZk4QuWVB6znTbm7pNwUmyr1HHiG+l+gEPCtkTEN60='
WHERE
key_id = '2149d4d2c46632a47d2531094eecb3705bacb360453aa63588951cc31dfde7f6'
AND (
token = 'XPZk4QuWVB6znTbm7pNwUmyr1HHiG+l+gEPCtkTEN60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)