UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Cbw8gUbMcFcQVpJJgUKFuA2gCja/IcJ+KRwSQmnrsA='
WHERE
key_id = 'e23ffde01bb9975079979a1244a6a8988920addb94bd0d25ed842d1f4f7023e2'
AND (
token = '5Cbw8gUbMcFcQVpJJgUKFuA2gCja/IcJ+KRwSQmnrsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)