UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y3a1ZREhB8tCJyZgOJL4xS29Oi1nbELseK0/65Mo1Q8='
WHERE
key_id = '8dc5229fd55f42e83c8e34fdaa7a5220daacc72833c24bd9a3b1f3985dd72a2c'
AND (
token = 'Y3a1ZREhB8tCJyZgOJL4xS29Oi1nbELseK0/65Mo1Q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)