UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rYznerpTtCJwlxh3aWYS5Gkb+D6jw+m0aYdKoHNY26w='
WHERE
key_id = 'b25b1efa7861f5a98f4fa1604e26cc13fab7802f369be1406a3ad1d7e760cac0'
AND (
token = 'rYznerpTtCJwlxh3aWYS5Gkb+D6jw+m0aYdKoHNY26w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)