UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HwCp36ZLU+9mGMzXOcnNetQpNlldvrCRCH0toZZkokE='
WHERE
key_id = '28116f013619ac5f7b191e311a167881ba552ac03a5f86941422ce971e5b7f77'
AND (
token = 'HwCp36ZLU+9mGMzXOcnNetQpNlldvrCRCH0toZZkokE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)