UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pN26TJ1hczqjYapb3P3R7ocG7bCp9TEJTI1NS0hqbaA='
WHERE
key_id = 'b6eefbe4b30ff314a30268dbf88180dfe6bb13f9b036cf8bb4d407e3909bff71'
AND (
token = 'pN26TJ1hczqjYapb3P3R7ocG7bCp9TEJTI1NS0hqbaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)