UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '25ycRXGDv11mWNzB7DV5BaxkvqkltJ4nYdjXoVXh0qU='
WHERE
key_id = '2ae53025c7319f718f72c52c5fb7c215f517bf548806e1b62ace37bbe2db2b97'
AND (
token = '25ycRXGDv11mWNzB7DV5BaxkvqkltJ4nYdjXoVXh0qU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)