UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Z4i7BV0ivkMNtOeYjRhkNWKZXvAW3ayqY8hz789vCE='
WHERE
key_id = '438924d4c82463489b31467f83002362edd7f0d1a3d32b5898d59491eac5382c'
AND (
token = '/Z4i7BV0ivkMNtOeYjRhkNWKZXvAW3ayqY8hz789vCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)