UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T4gNeMARW/6djqf6jhpV3ji49lIgEl6m2U6+mav/CfU='
WHERE
key_id = 'f0306027181cbbcf4d5cfccd8d330cd4d2bc6f601e1975554b0d2f849aab32e4'
AND (
token = 'T4gNeMARW/6djqf6jhpV3ji49lIgEl6m2U6+mav/CfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)