UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'khp7gNDXDfgNvBU84lPC7CpNwLLwwfqqnvfCJEDCfmQ='
WHERE
key_id = '6fef3ad99427ad1eb3bd0d573b889946ebe3ee0976f6193b0828acd57987cf37'
AND (
token = 'khp7gNDXDfgNvBU84lPC7CpNwLLwwfqqnvfCJEDCfmQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)