UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9BwIQ/pDRyARCjVfyBCXEXBCpsJs4SdCi1IaJ70nz4='
WHERE
key_id = 'e2c79ff75afd808a265f201ee1162fe3007fe57d8de845d942dbfff7406d4106'
AND (
token = 'N9BwIQ/pDRyARCjVfyBCXEXBCpsJs4SdCi1IaJ70nz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)