UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JzP0mVE6DqfuXpOS3oPjd7t11x10/IdYQ1H0auMxrZs='
WHERE
key_id = 'e7effda6bd12edc8af39fac2b1284daeaa966fa25e4ce512a97de542386e67b3'
AND (
token = 'JzP0mVE6DqfuXpOS3oPjd7t11x10/IdYQ1H0auMxrZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)