UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZJWzk4lkwNT2hPYmI/UKbGfHUncZCm57d6z/utSxBZ8='
WHERE
key_id = '0d63c20ddb52f185a1384fee0c8a3b6b0359f47a3a9314b1f48f4274df1f9bca'
AND (
token = 'ZJWzk4lkwNT2hPYmI/UKbGfHUncZCm57d6z/utSxBZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)