UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2SyZ9JsZM9tU3N/fFnaeQhRJQnLJ+WIc5gShrsV8wHA='
WHERE
key_id = '3f16cdae9311b366e3537350808ecddd15150c0b7e2cbba78d7732dc33267ad5'
AND (
token = '2SyZ9JsZM9tU3N/fFnaeQhRJQnLJ+WIc5gShrsV8wHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)