UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i4cIoGq/LRpt4MNOCCLrdwUF0v9snN4CmtMFup8U9ok='
WHERE
key_id = 'c24ae5a0b92c214bfbdf31b641fade21cfa343d17fc2514d33e03b8fe97f99fb'
AND (
token = 'i4cIoGq/LRpt4MNOCCLrdwUF0v9snN4CmtMFup8U9ok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)