UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+llJx11UnGA2QSkRaWqapRxVco8p3ZbC+uf6c66lkQ='
WHERE
key_id = 'b25c9954f833ba7c696008c0e4ac61d01629cb46284803eeeeaff8947f51ae06'
AND (
token = 'X+llJx11UnGA2QSkRaWqapRxVco8p3ZbC+uf6c66lkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)